RANK_EQ

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the top rank of that set of values is returned.

Syntax

expression.RANK_EQ(arg1, arg2, arg3);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange	ApiName	number
arg2	Required	ApiRange	ApiName	number[]
arg3	Required	ApiRange	ApiName	boolean

Returns

number

Example

const oWorksheet = Api.GetActiveSheet();

var valueArr = [7, 6, 5, 5];

// Place the numbers in cells
for (var i = 0; i < valueArr.length; i++) {
  oWorksheet.GetRange("A" + (i + 1)).SetValue(valueArr[i]);
}

//method params
var number = oWorksheet.GetRange("A3");
var range = oWorksheet.GetRange("A1:A4");
var order = 0;

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.RANK_EQ(number, range, order);

oWorksheet.GetRange("C1").SetValue(ans);